Forum Discussion

v-flguim's avatar
v-flguim
New Member
9 years ago
Solved

Average

I'm starting to use power bi and included a bar graphic, but I want use average into value and I only have Count as option. Someone knows how to do this, please?  
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi v-flguim,

 

Average() function is not available to the Text data type column. You need to set the field data type as Numbers then Average aggregation will be available.

 

 

 

 

Best Regards,
Qiuyun Yu